2015-09-15 - 21623 - Rel Notes - Regional bex query creation for EPM260 #2015BIReleaseNotes

Release Notes

21623 - Regional bex query creation for EPM260

Admin Info


Purpose
 Need to create Regional BEx Queries for regional reports.
Release No
 001
Submitted on
 15/09/2015
Submitted by
 Naveen G
Environment
 BPD to BPQ & BPP
Sent To
 Saravanan Lakshmanan
Object(s) created by
 Naveen G
Object(s) tested by
 Naveen G
Transport Status
 Released

NEC BEx Standards Check

1. BEx query has been successfully checked against the NEC Standard BEx checklist.
2. NEC Standard checklist & Regional BEx Queries list has been attached here for reference:
ZEM_BPC_Q001 NEC Standard Query Checklist.xls
EPM260 - Regional BEx Queries List.xls

Transport and Technical Objects


SNo
 Transport ID
 Description
 Object Name
1
 BPDK902604
 BW: Add SeasonCons field in OO, Cond & COPA Regional Sources.
 Z_OPN, Z_COND and ZCOPA_Z_CNTR.
2
 BPDK902602
 BW: Add Category & SeasonCons fields to Regional BPC Sources.
 ZNA_BPC, ZEA_BPC, ZEM_BPC, ZEJ_BPC and ZJA_BPC.
3
 BPDK902610
 BW: BEx Reg.Queries for NA, EmerAmer & EMEA regions - EPM260.
 Document attached above in NEC BEx Standards section.
4
 BPDK902612
 BW: BEx Reg.Queries for Japan & Emer.Japac regions - EPM260.
 Document attached above in NEC BEx Standards section.

Release Notes

For Infrastructure

1. Need to move the transport requests to BPQ & BPP.
2. Need to move the transport requests in the same sequence as specified above.

For Requestor

1. First transport request will move the changes to add Season Consolidation field(ZSEACOLCN) in Open Order, Contract, Condtition & COPA SPO's.
2. Second transport request will move the changes to add Category(ZBPCMG5) & Season Consolidation field(ZSEACOLCN) in BPC regional Sources.
3. Third transport request will move the new BEx Queries for North America, Emerging Americas & EMEA regions to BPQ & BPP.
4. Fourth transport request will move the new BEx Queries for Emerging Japac & Japan regions to BPQ & BPP.

Test Notes

System : BPD

SNo
 Test Scenario
 Expected Results
1
 Check if the navigational attribute 0MAT_SALES_0MATL_GRP5
is populated with data successfully for regional Sources.
 Navigational attribute 0MAT_SALES_0MATL_GRP5 is populated with data successfully.
2
 Check if the BEx queries are validated successfully against the NEC standard Checklist.
 All the BEx Queries are validated successfully against the NEC standard Checklist.
3
 Check if all the objects are collected into the transport request.
 All the objetcs are collected successfully into the transport request.

Reference Document(Specification)

2015-09-08 - 21623 - Spec - Regional bex query creation for EPM260